/****** 对象:  Table [dbo].[UserInfo]    脚本日期: 03/08/2010 12:20:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS ( SELECT  *
                FROM    sys.objects
                WHERE   object_id = OBJECT_ID(N'[dbo].[UserInfo]')
                        AND type IN ( N'U' ) ) 
    BEGIN
        CREATE TABLE [dbo].[UserInfo]
            (
              [UserID] [int] IDENTITY(1, 1)
                             NOT NULL ,
              [UserName] [varchar](20) COLLATE Chinese_PRC_CI_AS
                                       NOT NULL ,
              [RealName] [nvarchar](8) COLLATE Chinese_PRC_CI_AS
                                       NOT NULL ,
              [Age] [tinyint] NOT NULL ,
              [Sex] [bit] NOT NULL ,
              [Mobile] [char](11) COLLATE Chinese_PRC_CI_AS
                                  NULL ,
              [Phone] [char](11) COLLATE Chinese_PRC_CI_AS
                                 NULL ,
              [Email] [varchar](50) COLLATE Chinese_PRC_CI_AS
                                    NOT NULL ,
              CONSTRAINT [PK_UserInfo] PRIMARY KEY CLUSTERED ( [UserID] ASC )
                WITH ( IGNORE_DUP_KEY = OFF )
            )
    END
GO
IF NOT EXISTS ( SELECT  *
                FROM    sys.indexes
                WHERE   object_id = OBJECT_ID(N'[dbo].[UserInfo]')
                        AND name = N'IX_UserName' ) 
    CREATE UNIQUE NONCLUSTERED INDEX [IX_UserName] ON [dbo].[UserInfo] 
    (
    [UserName] ASC
    )WITH (IGNORE_DUP_KEY = ON)
GO
SET IDENTITY_INSERT [dbo].[UserInfo] ON
INSERT  [dbo].[UserInfo]
        ( [UserID] ,
          [UserName] ,
          [RealName] ,
          [Age] ,
          [Sex] ,
          [Mobile] ,
          [Phone] ,
          [Email]
        )
VALUES  ( 1 ,
          N'zhangfei' ,
          N'测试859' ,
          36 ,
          1 ,
          N'13455663420' ,
          N'03517890360' ,
          N'zhangfei@msn.com'
        )
INSERT  [dbo].[UserInfo]
        ( [UserID] ,
          [UserName] ,
          [RealName] ,
          [Age] ,
          [Sex] ,
          [Mobile] ,
          [Phone] ,
          [Email]
        )
VALUES  ( 2 ,
          N'asddf' ,
          N'测试80' ,
          38 ,
          1 ,
          N'13455663421' ,
          N'03517890361' ,
          N'guanyu@163.com'
        )
INSERT  [dbo].[UserInfo]
        ( [UserID] ,
          [UserName] ,
          [RealName] ,
          [Age] ,
          [Sex] ,
          [Mobile] ,
          [Phone] ,
          [Email]
        )
VALUES  ( 3 ,
          N'liubei' ,
          N'刘备' ,
          42 ,
          1 ,
          N'13455663422' ,
          N'03517890362' ,
          N'liubei@163.net'
        )
INSERT  [dbo].[UserInfo]
        ( [UserID] ,
          [UserName] ,
          [RealName] ,
          [Age] ,
          [Sex] ,
          [Mobile] ,
          [Phone] ,
          [Email]
        )
VALUES  ( 4 ,
          N'zhougong' ,
          N'周公' ,
          29 ,
          1 ,
          N'13455663423' ,
          N'03517890363' ,
          N'zhoufoxcn@tom.com'
        )
INSERT  [dbo].[UserInfo]
        ( [UserID] ,
          [UserName] ,
          [RealName] ,
          [Age] ,
          [Sex] ,
          [Mobile] ,
          [Phone] ,
          [Email]
        )
VALUES  ( 5 ,
          N'zhaoyun' ,
          N'赵云' ,
          32 ,
          1 ,
          N'13455663424' ,
          N'03517890364' ,
          N'zhaoyun@sohu.com'
        )
INSERT  [dbo].[UserInfo]
        ( [UserID] ,
          [UserName] ,
          [RealName] ,
          [Age] ,
          [Sex] ,
          [Mobile] ,
          [Phone] ,
          [Email]
        )
VALUES  ( 6 ,
          N'huanggai' ,
          N'黄盖' ,
          50 ,
          1 ,
          N'13455663425' ,
          N'03517890365' ,
          N'huanggai@live.com'
        )
INSERT  [dbo].[UserInfo]
        ( [UserID] ,
          [UserName] ,
          [RealName] ,
          [Age] ,
          [Sex] ,
          [Mobile] ,
          [Phone] ,
          [Email]
        )
VALUES  ( 7 ,
          N'zhugeliang' ,
          N'诸葛亮' ,
          27 ,
          1 ,
          N'13455663426' ,
          N'03517890366' ,
          N'zhugeliang@hotmail.com'
        )
INSERT  [dbo].[UserInfo]
        ( [UserID] ,
          [UserName] ,
          [RealName] ,
          [Age] ,
          [Sex] ,
          [Mobile] ,
          [Phone] ,
          [Email]
        )
VALUES  ( 8 ,
          N'jiangwei' ,
          N'姜维' ,
          22 ,
          1 ,
          N'13455663427' ,
          N'03517890367' ,
          N'jiangwei@netease.com'
        )
INSERT  [dbo].[UserInfo]
        ( [UserID] ,
          [UserName] ,
          [RealName] ,
          [Age] ,
          [Sex] ,
          [Mobile] ,
          [Phone] ,
          [Email]
        )
VALUES  ( 9 ,
          N'caocao' ,
          N'曹操' ,
          48 ,
          1 ,
          N'13455663428' ,
          N'03517890368' ,
          N'caocao@qq.com'
        )
INSERT  [dbo].[UserInfo]
        ( [UserID] ,
          [UserName] ,
          [RealName] ,
          [Age] ,
          [Sex] ,
          [Mobile] ,
          [Phone] ,
          [Email]
        )
VALUES  ( 10 ,
          N'guojia' ,
          N'郭嘉' ,
          32 ,
          1 ,
          N'13455663429' ,
          N'03517890369' ,
          N'guojia@21cn.com'
        )
INSERT  [dbo].[UserInfo]
        ( [UserID] ,
          [UserName] ,
          [RealName] ,
          [Age] ,
          [Sex] ,
          [Mobile] ,
          [Phone] ,
          [Email]
        )
VALUES  ( 11 ,
          N'sunquan' ,
          N'孙权' ,
          33 ,
          1 ,
          N'13455663430' ,
          N'03517890370' ,
          N'sunquan@gmail.com'
        )
INSERT  [dbo].[UserInfo]
        ( [UserID] ,
          [UserName] ,
          [RealName] ,
          [Age] ,
          [Sex] ,
          [Mobile] ,
          [Phone] ,
          [Email]
        )
VALUES  ( 12 ,
          N'diaochan' ,
          N'貂禅' ,
          20 ,
          0 ,
          N'13455663431' ,
          N'03517890371' ,
          N'diaochan@sina.com.cn'
        )
INSERT  [dbo].[UserInfo]
        ( [UserID] ,
          [UserName] ,
          [RealName] ,
          [Age] ,
          [Sex] ,
          [Mobile] ,
          [Phone] ,
          [Email]
        )
VALUES  ( 13 ,
          N'yangyuhuan' ,
          N'杨玉环' ,
          24 ,
          0 ,
          N'13455663432' ,
          N'03517890372' ,
          N'yangyuhuang@chinaren.com'
        )
SET IDENTITY_INSERT [dbo].[UserInfo] OFF
